Lookup Table Manager
The Lookup Table Manager tool allows you to edit the values in commonly accessed lookup tables, so that each lookup does not have to be accessed individually.
Edit Lookup Table Values
-
Select Tools > System > Lookup Table Manager from the Main Menu.
The Lookup Table Manager displays.
-
Select the table you want to edit.
-
Click Edit.
The Edit Lookup window opens, listing the current values for the selected table.
-
Add a new value to the table:
-
Click New.
The New Lookup Table Values window opens.
-
Enter the code name in the Code Name field.
-
Enter the code description in the Code Description field.
-
Click Save.
The Edit Lookup window appears and your new value is in the list of values.
-
-
Edit an existing table value:
-
Select the record you want to modify.
-
Click Edit.
The Edit Lookup Table Values window opens.
-
Make your changes.
-
Click Save.
The Edit Lookup window appears.
-
-
Remove a table value:
-
Select the record you want to remove.
-
Click the Delete button.
A dialog box opens, asking you to confirm your choice.
-
Click Yes.
The Edit Lookup window refreshes, and the record no longer appears in the list.
-
-
Click Close.
The Lookup Table Manager page appears.
-
Click Close.
Add New Lookup Table
The Tasks module includes a feature that allows you to connect reading fields to lookup tables.
Create a new lookup table:
-
Select Tools > System > Lookup Table Manager from the Main Menu.
The Lookup Table Manager appears.
-
Click New.
The New Lookup Table window opens.
-
Enter the desired table name in the Lookup Table field.
Table names must not begin with numbers or special characters. The name must also not contain spaces.
-
Enter a description for the table in the Description field.
-
Select Yes from the Enabled? field if this lookup table should be enabled.
-
Click Save.
The Lookup Table Manager appears with your new table in the list.
-
Follow the Edit Lookup Table Values procedures above to add values to your lookup table.